package io.renren.dao;

import io.renren.common.dao.BaseDao;
import io.renren.dto.CollarDTO;
import io.renren.entity.CollarEntity;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

/**
 * 辅材领用表
 *
 * @author 罗胜平 781757616@qq.com
 * @since 1.0.0 2019-11-22
 */
@Mapper
public interface CollarDao extends BaseDao<CollarEntity> {
    @Select("SELECT  COUNT(*) as pending   from  canteens_collar where  `status` = '${status}'  ${chedId}  ${clerkId}  ${canteen_Id} ")
    CollarDTO getTotal(String chedId, String clerkId, String canteen_Id , int status);
}